﻿CREATE TABLE [core].[LienHolder] (
    [LienHolderID] INT           IDENTITY (1, 1) NOT NULL,
    [Name]         VARCHAR (500) NULL,
    [Street]       VARCHAR (500) NULL,
    [City]         VARCHAR (50)  NULL,
    [State]        VARCHAR (2)   NULL,
    [Zip]          VARCHAR (9)   NULL,
    [Phone]        VARCHAR (50)  NULL,
    [CreatedBy]    VARCHAR (50)  NULL,
    [CreatedDate]  DATETIME      NULL,
    [UpdatedBy]    VARCHAR (50)  NULL,
    [UpdatedDate]  DATETIME      NULL,
    [EndDate]      DATETIME      NULL,
    CONSTRAINT [PK_LienHolder] PRIMARY KEY CLUSTERED ([LienHolderID] ASC)
);

